package com.think.teaching.mapper;

import java.util.List;

import org.apache.ibatis.annotations.One;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.FetchType;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.think.teaching.model.College;
import com.think.teaching.model.School;

public interface SchoolMapper extends BaseMapper<School> {

	
	@Select("SELECT * FROM college WHERE school=#{id} AND state=1 AND delflag=0")
	List<College> selectSchoolColleges(Integer id);
	
	@Select("SELECT id,name FROM school WHERE id=#{college}")
	School getInfoById(Integer school);
}
